﻿CREATE PROCEDURE [dbo].[proc_ContratosOpcoesRefeicaoInsert]
(
	@IdRefeicaoContratada bigint,
	@CodOpcao nvarchar(3),
	@Descricao nvarchar(255)
)
AS
BEGIN

	SET NOCOUNT OFF
	DECLARE @Err int

	INSERT
	INTO [ContratosOpcoesRefeicao]
	(
		[IdRefeicaoContratada],
		[CodOpcao],
		[Descricao],
		[DataCriacao],
		[DataAlteracao]
	)
	VALUES
	(
		@IdRefeicaoContratada,
		@CodOpcao,
		@Descricao,
		GETDATE(),
		GETDATE()
	)

	SET @Err = @@Error


	RETURN @Err
END
